Introduction to Data Warehouses

Welcome to this lesson on Introduction to Data Warehouses!

Objective

Students will be able to understand the purpose, architecture, and technologies used in a data warehouse.

Prerequisites

• Relational database design & SQL
• Programming in Python
• Basic familiarity with dimensional modeling

Lesson Overview

• What is a Data Warehouse? A Business Perspective
• What is a Data Warehouse? A Technical Perspective
• Dimensional Modeling (Recap)
• DWH Architecture
• OLAP Cubes
• DWH Storage Technology